MATCH_PALLET_TYPE_BY_ID = "MATCH (p:MaterialPalletType {materialPalletTypeId: $materialPalletTypeId}) RETURN p"

GET_MATERIAL_PALLET_TYPE_LIST = '''
MATCH (p:MaterialPalletType)
{where}
RETURN p
'''

CREATE_MATERIAL_PALLET_TYPE = '''
CREATE (p:MaterialPalletType {
    materialPalletTypeId: $materialPalletTypeId,
    materialPalletTypeName: $materialPalletTypeName,
    createdBy: $createdBy,
    createdAt: $createdAt,
    updatedBy: $updatedBy,
    updatedAt: $updatedAt
})
RETURN p
'''

UPDATE_MATERIAL_PALLET_TYPE = 'MATCH (p:MaterialPalletType {materialPalletTypeId: $materialPalletTypeId}) SET {set_clauses} RETURN p'

DELETE_MATERIAL_PALLET_TYPE_REL = 'MATCH (b:WorkBench)-[r:WORKBENCH_PALLET_TYPE]->(p:MaterialPalletType {materialPalletTypeId: $materialPalletTypeId}) DELETE r'

DELETE_MATERIAL_PALLET_TYPE = 'MATCH (p:MaterialPalletType {materialPalletTypeId: $materialPalletTypeId}) DETACH DELETE p'

GET_WORKBENCH_PALLET_TYPES = 'MATCH (b:WorkBench {benchId: $benchId})-[:WORKBENCH_PALLET_TYPE]->(p:MaterialPalletType) RETURN p'

CHECK_PALLET_TYPE_EXISTS = "MATCH (p:MaterialPalletType {materialPalletTypeId: $materialPalletTypeId}) RETURN p"

# 可继续补充material_pallet_type相关Cypher语句 